Parameters Provided:
name.synonym = ethyl 2-{[5,11,17,23-tetra(tert-butyl)-26,27,28-tris(2-ethoxy-2-oxyethoxy)pentacyclo[19.3.1.1~3,7~.1~9,13~.1~15,19~]octacosa-1(25),3(28),4,6,9(27),10,12,15,17,19,(26),21,23-dodecaen-25-yl]oxy}acetate
filter.purchasability = all
page.num = 1
Structural Results Found: (before additional filtering)
SQL Query Was
SELECT DISTINCT(ci.sub_id_fk) AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id INNER JOIN synonym AS syn ON (ci.cat_id_fk=syn.cat_fk AND ci.supplier_code=syn.supplier_code) INNER JOIN field AS f ON syn.field_fk=f.field_id WHERE c.free = 1 AND syn.synonym IS NOT NULL AND syn.synonym LIKE 'ethyl 2-{[5,11,17,23-tetra(tert-butyl)-26,27,28-tris(2-ethoxy-2-oxyethoxy)pentacyclo[19.3.1.1~3,7~.1~9,13~.1~15,19~]octacosa-1(25),3(28),4,6,9(27),10,12,15,17,19,(26),21,23-dodecaen-25-yl]oxy}acetate' AND f.ftype IN (3,7,11,12,14) AND ci.sub_id_fk IN (SELECT ci.sub_id_fk AS sub_id FROM catalog_item AS ci INNER JOIN catalog AS c ON ci.cat_id_fk=c.cat_id WHERE c.free = 1 ) LIMIT 50
Permalink
//zinc12.docking.org/results/combination?name.synonym=ethyl+2-%7B%5B5%2C11%2C17%2C23-tetra%28tert-butyl%29-26%2C27%2C28-tris%282-ethoxy-2-oxyethoxy%29pentacyclo%5B19.3.1.1%7E3%2C7%7E.1%7E9%2C13%7E.1%7E15%2C19%7E%5Doctacosa-1%2825%29%2C3%2828%29%2C4%2C6%2C9%2827%29%2C10%2C12%2C15%2C17%2C19%2C%2826%29%2C21%2C23-dodecaen-25-yl%5Doxy%7Dacetate&filter.purchasability=all
Embed Link to Results